I need to highlight the lowest value number in each column of my spreadsheet. I'm trying to use the conditional highlight but I can't find a function to work like I need.
MacBook Pro (Retina, 13-inch, Late 2013), iOS 9.3.5
One way would be to calculate the MIN in a cell in a Footer Row, select the cells in the body of the column and apply Conditional Highlighting like this:
You have to click the address token first, then select the comparison cell, here A8, then make sure to preserve row and column.
The formula in A8 of the example is =MIN(A).
The result is a bolded 2 (not shown in screenshots).
SG
How do I highlight min value in a colum?
